<?php
    include_once '../../../../controlador/php/conexion/Conexion.php';
    $con = new Conexion();
    
    $medl = "select ".$con->getReal()."..GENUSUARIO.OID,USUDESCRI from ".$con->getReal()."..GENUSUARIO
            inner join ".$con->getReal()."..GENROL on ".$con->getReal()."..GENUSUARIO.GENROL = GENROL.OID
            where
            ROLNOMBRE like '%laborato%'
            and USUESTADO='1'";
    $resp = $con->query($medl);
    
    while ($respu = mssql_fetch_array($resp)){
        $medicos[] = $respu;
    }
    
    print_r(json_encode($medicos));
    
    mssql_close();
?>
